<!DOCTYPE html>
<html lang="zh-CN">
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <meta name="robots" content="noodp" />
        <meta http-equiv="X-UA-Compatible" content="IE=edge, chrome=1">
        <title>《SqlServer服务远程调用失败》 - Lucklyの博客 - 在阅读中遇见自己</title><meta name="Description" content="早起的年轻人做的网站"><meta property="og:title" content="《SqlServer服务远程调用失败》" />
<meta property="og:description" content="
本文主要介绍
" />
<meta property="og:type" content="article" />
<meta property="og:url" content="https://luckly.work/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5/" />
<meta property="og:image" content="https://luckly.work/logo.png"/>
<meta property="article:published_time" content="2021-05-27T07:09:54+08:00" />
<meta property="article:modified_time" content="2021-05-27T07:09:54+08:00" />
<meta name="twitter:card" content="summary_large_image"/>
<meta name="twitter:image" content="https://luckly.work/logo.png"/>

<meta name="twitter:title" content="《SqlServer服务远程调用失败》"/>
<meta name="twitter:description" content="
本文主要介绍
"/>
<meta name="application-name" content="LoveIt">
<meta name="apple-mobile-web-app-title" content="LoveIt"><meta name="theme-color" content="#ffffff"><meta name="msapplication-TileColor" content="#da532c"><link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" />
        <link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png">
        <link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png"><link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png"><link rel="mask-icon" href="/safari-pinned-tab.svg" color="#5bbad5"><link rel="manifest" href="/site.webmanifest"><link rel="canonical" href="https://luckly.work/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5/" /><link rel="prev" href="https://luckly.work/win10%E5%AE%89%E8%A3%85iis%E5%B9%B6%E9%85%8D%E7%BD%AEasp.net4.0/" /><link rel="next" href="https://luckly.work/flutter%E4%B9%8Bdart%E7%A9%BA%E5%AE%89%E5%85%A8%E6%A6%82%E8%A7%88/" /><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/normalize.css@8.0.1/normalize.min.css"><link rel="stylesheet" href="/css/style.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@5.13.0/css/all.min.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/animate.css@3.7.2/animate.min.css"><script type="application/ld+json">
    {
        "@context": "http://schema.org",
        "@type": "BlogPosting",
        "headline": "《SqlServer服务远程调用失败》",
        "inLanguage": "zh-CN",
        "mainEntityOfPage": {
            "@type": "WebPage",
            "@id": "https:\/\/luckly.work\/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5\/"
        },"image": [{
                            "@type": "ImageObject",
                            "url": "https:\/\/luckly.work\/images\/Apple-Devices-Preview.png",
                            "width":  3200 ,
                            "height":  2048 
                        }],"genre": "posts","wordcount":  2182 ,
        "url": "https:\/\/luckly.work\/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5\/","datePublished": "2021-05-27T07:09:54+08:00","dateModified": "2021-05-27T07:09:54+08:00","license": "This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.","publisher": {
            "@type": "Organization",
            "name": "xxxx","logo": {
                    "@type": "ImageObject",
                    "url": "https:\/\/luckly.work\/images\/avatar.png",
                    "width":  528 ,
                    "height":  560 
                }},"author": {
                "@type": "Person",
                "name": "早起的年轻人"
            },"description": ""
    }
    </script></head>
    <body header-desktop="fixed" header-mobile="auto"><script type="text/javascript">(window.localStorage && localStorage.getItem('theme') ? localStorage.getItem('theme') === 'dark' : ('auto' === 'auto' ? window.matchMedia('(prefers-color-scheme: dark)').matches : 'auto' === 'dark')) && document.body.setAttribute('theme', 'dark');</script>

        <div id="mask"></div><div class="wrapper"><header class="desktop" id="header-desktop">
    <div class="header-wrapper">
        <div class="header-title">
            <a href="/" title="Lucklyの博客 - 在阅读中遇见自己"><span class="header-title-pre"><i class='far fa-kiss-wink-heart fa-fw'></i></span><span id="id-1" class="typeit"></span></a>
        </div>
        <div class="menu">
            <div class="menu-inner"><a class="menu-item" href="/posts/"> 所有文章 </a><a class="menu-item" href="/categories/flutter/"> Flutter </a><a class="menu-item" href="/categories/read/"> 读书笔记 </a><a class="menu-item" href="/categories/go/"> Go </a><a class="menu-item" href="/tags/"> 标签 </a><a class="menu-item" href="/categories/"> 分类 </a><a class="menu-item" href="/about/"> 关于 </a><a class="menu-item" href="https://github.com/ITmxs" title="GitHub" rel="noopener noreffer" target="_blank"><i class='fab fa-github fa-fw'></i> Github </a><a class="menu-item" href="/friend/"><i class='fas fa-user-friends'></i> 友链 </a><span class="menu-item delimiter"></span><span class="menu-item search" id="search-desktop">
                        <input type="text" placeholder="搜索文章标题或内容..." id="search-input-desktop">
                        <a href="javascript:void(0);" class="search-button search-toggle" id="search-toggle-desktop" title="搜索">
                            <i class="fas fa-search fa-fw"></i>
                        </a>
                        <a href="javascript:void(0);" class="search-button search-clear" id="search-clear-desktop" title="清空">
                            <i class="fas fa-times-circle fa-fw"></i>
                        </a>
                        <span class="search-button search-loading" id="search-loading-desktop">
                            <i class="fas fa-spinner fa-fw fa-spin"></i>
                        </span>
                    </span><a href="javascript:void(0);" class="menu-item theme-switch" title="切换主题">
                    <i class="fas fa-adjust fa-fw"></i>
                </a>
            </div>
        </div>
    </div>
</header><header class="mobile" id="header-mobile">
    <div class="header-container">
        <div class="header-wrapper">
            <div class="header-title">
                <a href="/" title="Lucklyの博客 - 在阅读中遇见自己"><span class="header-title-pre"><i class='far fa-kiss-wink-heart fa-fw'></i></span><span id="id-2" class="typeit"></span></a>
            </div>
            <div class="menu-toggle" id="menu-toggle-mobile">
                <span></span><span></span><span></span>
            </div>
        </div>
        <div class="menu" id="menu-mobile"><div class="search-wrapper">
                    <div class="search mobile" id="search-mobile">
                        <input type="text" placeholder="搜索文章标题或内容..." id="search-input-mobile">
                        <a href="javascript:void(0);" class="search-button search-toggle" id="search-toggle-mobile" title="搜索">
                            <i class="fas fa-search fa-fw"></i>
                        </a>
                        <a href="javascript:void(0);" class="search-button search-clear" id="search-clear-mobile" title="清空">
                            <i class="fas fa-times-circle fa-fw"></i>
                        </a>
                        <span class="search-button search-loading" id="search-loading-mobile">
                            <i class="fas fa-spinner fa-fw fa-spin"></i>
                        </span>
                    </div>
                    <a href="javascript:void(0);" class="search-cancel" id="search-cancel-mobile">
                        取消
                    </a>
                </div><a class="menu-item" href="/posts/" title="">所有文章</a><a class="menu-item" href="/categories/flutter/" title="">Flutter</a><a class="menu-item" href="/categories/read/" title="">读书笔记</a><a class="menu-item" href="/categories/go/" title="">Go</a><a class="menu-item" href="/tags/" title="">标签</a><a class="menu-item" href="/categories/" title="">分类</a><a class="menu-item" href="/about/" title="">关于</a><a class="menu-item" href="https://github.com/ITmxs" title="GitHub" rel="noopener noreffer" target="_blank"><i class='fab fa-github fa-fw'></i>Github</a><a class="menu-item" href="/friend/" title=""><i class='fas fa-user-friends'></i>友链</a><a href="javascript:void(0);" class="menu-item theme-switch" title="切换主题">
                <i class="fas fa-adjust fa-fw"></i>
            </a></div>
    </div>
</header>
<div class="search-dropdown desktop">
    <div id="search-dropdown-desktop"></div>
</div>
<div class="search-dropdown mobile">
    <div id="search-dropdown-mobile"></div>
</div>
<main class="main">
                <div class="container"><div class="toc" id="toc-auto">
            <h2 class="toc-title">目录</h2>
            <div class="toc-content" id="toc-content-auto"></div>
        </div><article class="page single"><h1 class="single-title animated flipInX">《SqlServer服务远程调用失败》</h1><div class="post-meta">
            <div class="post-meta-line"><span class="post-author"><a href="/" title="Author" rel=" author" class="author"><i class="fas fa-user-circle fa-fw"></i>早起的年轻人</a></span></div>
            <div class="post-meta-line"><i class="far fa-calendar-alt fa-fw"></i>&nbsp;<time datetime="2021-05-27">2021-05-27</time>&nbsp;<i class="fas fa-pencil-alt fa-fw"></i>&nbsp;约 2182 字&nbsp;
                <i class="far fa-clock fa-fw"></i>&nbsp;预计阅读 5 分钟&nbsp;</div>
        </div><div class="details toc" id="toc-static"  kept="">
                <div class="details-summary toc-title">
                    <span>目录</span>
                    <span><i class="details-icon fas fa-angle-right"></i></span>
                </div>
                <div class="details-content toc-content" id="toc-content-static"><nav id="TableOfContents"></nav></div>
            </div><div class="content" id="content"><blockquote>
<p>本文主要介绍</p>
</blockquote>
<p>参考链接   <a href="https://blog.csdn.net/u010850027/article/details/43410137">https://blog.csdn.net/u010850027/article/details/43410137</a></p>
<p>由于开发系统，需要vs版本统一，于是经过了昨天一整天艰苦卓绝的斗争，小编终于成功的写在了13版本的vs，重新装上了12版本的vs，本来想着，12版本的vs搭建成功了，就赶快搭建框架，然后敲例子，可是天意弄人，小编的数据库神奇般的打不开了，又经过半天的百度，问题答案渐渐浮出水面，接下来小编就简单的介绍一下如何解决Sql Server服务远程过程调用失败的问题，打开sql，连接上，出现一下问题：</p>
<p>第一种方法，如下所示</p>
<p>这个问题，小编肿么有种似曾相识的赶脚nie，原来早在2014年9月1号的时候，小编已经和这个问题有过一面之缘，详情请见链接在与SQL Server建立连接时出现与网络相关的或特定于实例的错误，于是小编就循着上次解决方法的脚步，开始解决问题，可是天意弄人，虽然出了同样的错误，可是不一定是同样的原因所导致，于是小编就开始了一段百度之路。接下来，小编就来和大家分享一下如何解决Sql Server服务远程过程调用失败的解决方法，小编拖着腮帮想，可能是这台电脑之前安装了 visual studio 2013，内置的SQl server 2012与之冲突，导致新的2008 R2 版本过低导致。出现如下图所示的错误：</p>
<pre><code>  奇怪，之前所有的服务都不见了，被妖怪抓走了，开玩笑`(*∩_∩*)′，通过网上查，才知道是因为SQL Server2008 与VS2012 共存的问题，当你电脑中同时装了这两样东西，SQL 就会出现上图中的情况。解决办法：从控制面板或者其他辅助软件中找到”Microsoft SQL Server Expres 2012LocalDB“将其卸载即可，如下图所示：
</code></pre>
<p>​</p>
<pre><code>   卸载之后，重新刷新一下，“SQL Server服务”就出出来，如下图，然后再按照下图中的第二个红线框将已停止的SQL Server(MSSQLSERVER)启动即可。如下图所示：
</code></pre>
<p>​</p>
<pre><code>     到此为止，很多小伙伴的问题应该能够解决，可能有些小伙伴由于RP的原因，当启动SQL Server（MSSQLSERVER）之后又出现了新的问题。具体如下图： 
</code></pre>
<p>​</p>
<pre><code>     通过查看windows日志文件（查看日志文件的方法）就能看出是因为端口被占用的原因，解决这个问题也挺容易的，只需要将SQLEXPRESS服务中后面三个都关掉，保证每次启动只有一个启动就好。问题终于解决了。如下所示：
</code></pre>
<p>​</p>
<pre><code>    而后，打开数据库，就可以连上了哦，出了上面的解决方法之外，小逼还向小伙伴简单介绍两种解决方法：



    第二种办法就是升级数据库
</code></pre>
<p>使用更高版本的数据库，或者升级SqlServer2008为SP1或者SP2。</p>
<pre><code>    第三种方法就是手动启动数据库服务项
    方法如下：
   右击“计算机”→“管理”→“服务”，找到SQL Server（MSSQLSERVER），右击，选择“启动”。此时登陆数据库不会有问题，但是重新启动系统后，问题会依旧存在的。



     小编寄语：该博文，小编主要简单的介绍了一下关于sql server服务远程过程调用失败问题的解决方法，终于明白，世界上最远的距离不是生与死，而是你坐在电脑面前却连不上数据库，出现问题，并不可怕，可怕的是我们被看似简单的东西我们的心，可能解决一个简单的问题会花上我们一个半天的时间，但是问题解决了的那种欣喜和高兴，比小时候吃大白兔奶糖还要开心，项目开发，未完待续......
</code></pre>
<p>错误日志：</p>
<p>SQL Server 无法生成 FRunCM 线程。请查看 SQL Server 错误日志和 Windows 事件日志，获取有关可能发生的相关问题的信息。</p>
<p>由于网络库中存在内部错误，所以无法启动网络库。要确定原因，请查看错误日志中紧位于此错误之前的那些错误。</p>
<p>TDSSNIClient 初始化失败，出现错误 0x7e，状态代码 0x1。原因: 初始化失败，出现基础结构错误。请检查以前的错误。 找不到指定的模块。</p>
<p>TDSSNIClient 初始化失败，出现错误 0x7e，状态代码 0x60。原因: 无法初始化 VIA 侦听器。 找不到指定的模块。</p>
<p>SQL Server 无法初始化 VIA 支持库 [QLVipl.dll]。这通常指示 VIA 支持库不存在或已损坏。请修复或禁用 VIA 网络协议。错误: 0x7e。</p>
<p>网络转载：</p>
<p>我们可以判定，可能会是以下问题，- 别处理如下：</p>
<p>1、可能是IP地址配置不对。解决方法- 下：</p>
<p>打开 Microsoft SQL Server 2005配置工具下的SQL Server Configuration Manager，选择mssqlserver协议, 然后双击右边窗口的TCP/IP，在弹出窗- 中检查IP配置。</p>
<p>一般来讲，默认的IP2是：127.0.0.1，如- 第一个IP地址的端口1433端口ping不通的- 话，服务无法启动。您可以将127.0.0.1- 在IP1上，那么不管IP2的端口是否能ping- 通，服务都能够正常启动。您也可以- IP1设置为当前机器的IP地址，并保证- IP地址的端口能够ping通。</p>
<p>2、可能是因为VIA协议启用造成的。解- 方法如下：</p>
<p>打开 Microsoft SQL Server 2005配置工具下的SQL Server Configuration Manager，选择mssqlserver协议, 然后右边窗口有个VIA，点击右键禁用- ，点击“确定”即可。这时候再启动s- qlserver服务即可,如果还不行,可以重新启动下电脑,我的就是禁用后还是不行,电脑重新启动后能用了！</p>
<p>另外，管理员密码修改也会造成sqlserve- r服务无法启动。解决方法如下：</p>
<p>打开 Microsoft SQL Server 2005配置工具下的SQL Server Configuration Manager，打开SQL Server属性，</p>
<p>将本帐户的密码修改为您更改之后的- 理员密码，“确定”即可。这时SQL Server服务应该就能正常启动了。</p>
<p>我的是VIA没有应用导致 ，禁用之后可以。但是由于机器名字改过，现在登陆不是，下续……</p></div><div class="post-footer" id="post-footer">
    <div class="post-info">
        <div class="post-info-line">
            <div class="post-info-mod">
                <span>更新于 2021-05-27</span>
            </div>
            <div class="post-info-license"></div>
        </div>
        <div class="post-info-line">
            <div class="post-info-md"></div>
            <div class="post-info-share">
                <span><a href="javascript:void(0);" title="分享到 Twitter" data-sharer="twitter" data-url="https://luckly.work/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5/" data-title="《SqlServer服务远程调用失败》"><i class="fab fa-twitter fa-fw"></i></a><a href="javascript:void(0);" title="分享到 Facebook" data-sharer="facebook" data-url="https://luckly.work/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5/"><i class="fab fa-facebook-square fa-fw"></i></a><a href="javascript:void(0);" title="分享到 Hacker News" data-sharer="hackernews" data-url="https://luckly.work/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5/" data-title="《SqlServer服务远程调用失败》"><i class="fab fa-hacker-news fa-fw"></i></a><a href="javascript:void(0);" title="分享到 Line" data-sharer="line" data-url="https://luckly.work/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5/" data-title="《SqlServer服务远程调用失败》"><i data-svg-src="https://cdn.jsdelivr.net/npm/simple-icons@2.14.0/icons/line.svg"></i></a><a href="javascript:void(0);" title="分享到 微博" data-sharer="weibo" data-url="https://luckly.work/sqlserver%E6%9C%8D%E5%8A%A1%E8%BF%9C%E7%A8%8B%E8%B0%83%E7%94%A8%E5%A4%B1%E8%B4%A5/" data-title="《SqlServer服务远程调用失败》"><i class="fab fa-weibo fa-fw"></i></a></span>
            </div>
        </div>
    </div>

    <div class="post-info-more">
        <section class="post-tags"></section>
        <section>
            <span><a href="javascript:void(0);" onclick="window.history.back();">返回</a></span>&nbsp;|&nbsp;<span><a href="/">主页</a></span>
        </section>
    </div>

    <div class="post-nav"><a href="/win10%E5%AE%89%E8%A3%85iis%E5%B9%B6%E9%85%8D%E7%BD%AEasp.net4.0/" class="prev" rel="prev" title="《Win10安装IIS并配置ASP.NET4 》"><i class="fas fa-angle-left fa-fw"></i>《Win10安装IIS并配置ASP.NET4 》</a>
            <a href="/flutter%E4%B9%8Bdart%E7%A9%BA%E5%AE%89%E5%85%A8%E6%A6%82%E8%A7%88/" class="next" rel="next" title="《Flutter之Dart空安全概览》">《Flutter之Dart空安全概览》<i class="fas fa-angle-right fa-fw"></i></a></div>
</div>
</article></div>
            </main><footer class="footer">
        <div class="footer-container"><div class="footer-line">由 <a href="https://gohugo.io/" target="_blank" rel="noopener noreffer" title="Hugo 0.79.1">Hugo</a> 强力驱动 | 主题 - <a href="https://github.com/dillonzq/LoveIt" target="_blank" rel="noopener noreffer" title="LoveIt 0.2.10"><i class="far fa-kiss-wink-heart fa-fw"></i> LoveIt</a>
                </div><div class="footer-line"><i class="far fa-copyright fa-fw"></i><span itemprop="copyrightYear">2021</span><span class="author" itemprop="copyrightHolder">&nbsp;<a href="/" target="_blank">早起的年轻人</a></span>&nbsp;|&nbsp;<span class="license"><a rel="license external nofollow noopener noreffer" href="https://creativecommons.org/licenses/by-nc/4.0/" target="_blank">CC BY-NC 4.0</a></span></div>
        </div>
    </footer></div>

        <div id="fixed-buttons"><a href="#" id="back-to-top" class="fixed-button" title="回到顶部">
                <i class="fas fa-arrow-up fa-fw"></i>
            </a><a href="#" id="view-comments" class="fixed-button" title="查看评论">
                <i class="fas fa-comment fa-fw"></i>
            </a>
        </div><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/cookieconsent@3.1.1/build/cookieconsent.min.css"><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/smooth-scroll@16.1.3/dist/smooth-scroll.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/autocomplete.js@0.37.1/dist/autocomplete.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/algoliasearch@4.2.0/dist/algoliasearch-lite.umd.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/lazysizes@5.2.2/lazysizes.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/clipboard@2.0.6/dist/clipboard.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/sharer.js@0.4.0/sharer.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/typeit@7.0.4/dist/typeit.min.js"></script><script type="text/javascript" src="https://cdn.jsdelivr.net/npm/cookieconsent@3.1.1/build/cookieconsent.min.js"></script><script type="text/javascript">window.config={"code":{"copyTitle":"复制到剪贴板","maxShownLines":10},"comment":{},"cookieconsent":{"content":{"dismiss":"同意","link":"了解更多","message":"本网站使用 Cookies 来改善您的浏览体验."},"enable":true,"palette":{"button":{"background":"#f0f0f0"},"popup":{"background":"#1aa3ff"}},"theme":"edgeless"},"data":{"id-1":"早起的年轻人","id-2":"早起的年轻人"},"search":{"algoliaAppID":"PASDMWALPK","algoliaIndex":"index.zh-cn","algoliaSearchKey":"b42948e51daaa93df92381c8e2ac0f93","highlightTag":"em","maxResultLength":10,"noResultsFound":"没有找到结果","snippetLength":50,"type":"algolia"},"typeit":{"cursorChar":"|","cursorSpeed":1000,"data":{"id-1":["id-1"],"id-2":["id-2"]},"duration":-1,"speed":100}};</script><script type="text/javascript" src="/js/theme.min.js"></script></body>
</html>
